﻿
-- 分包人员信息
create procedure [dbo].[PackageRyInfo_Get]
@fbid varchar(20) = null,
@sfzh varchar(18) = null,
@xm varchar(10)= null
as
select sfzh,xm,fbmc
from vRyFbInfo
where (@fbid is null or (isnull(fbid,'-1') like @fbid+'%'))
and (@sfzh is null or sfzh like @sfzh+'%')
and (@xm is null or xm like '%'+@xm+'%')